Nick Korna
Nick Korna
Reactions
-
Re: URL for a row of data
HI @alexis.ray89371 , Right click on the left hand side of the row (in the row number), then Properties. A small window will open with the Row Link as the last option. You can also click any cell in …1 · -
Re: Count if all, cells contain a specific word.
You'd change the formula to COUNTIFS and add in the extra column(s) & criteria. That the other column's value is calculated rather than directly input shouldn't matter. If you're looking for a si…2 · -
Re: 1st - 5th highest value that meets criteria - cross-sheet referencing
Hi @tina.hutchinson52776, On your Master List, you'll need to add a column for the rank in the category. This would have the formula: =IFERROR(RANKEQ([2023]@row, COLLECT([2023]:[2023], Category:Categ…1 · -
Re: Count the number of rows where a column (multi select dropdown) has more than one value
Hi @latheobald89201, This should work: =COUNTIF({Attendee Role}, COUNTM(@cell) >= 2) Hope this helps, but if you have any problems then post what they are! 😊2 · -
Re: Average with criteria
Hi @TorAtle Myrmel, If you're after an average for all the %ages in "Fullført" against rows containing "Mekanisk" in "System" then you would use the following formula: =…2 ·
